Title: SQL W3S (By-BKK) / 013 Delete
Tags: Obsidian_to_Anki

Q: What does the SQL DELETE statement do?
A: Deletes existing records from a table

Q: True/False: The WHERE clause in DELETE is optional
A: True, but without WHERE all records are deleted

Q: What is the syntax for deleting with a condition?
A: DELETE FROM table_name WHERE condition;

Q: Show an example deleting customer "Alfreds Futterkiste"
A: DELETE FROM Customers WHERE CustomerName='Alfreds Futterkiste';

Q: What happens if you omit WHERE in a DELETE statement?
A: All records in the table will be deleted

Q: How do you delete all rows but keep the table structure?
A: DELETE FROM table_name;

Q: How do you delete a table completely?
A: DROP TABLE table_name;

Q: True/False: DELETE removes table structure
A: False

Q: Deletes existing records from a table
A: What does the SQL DELETE statement do?

Q: DELETE FROM Customers WHERE CustomerName='Alfreds Futterkiste';
A: Show an example deleting a specific customer

Q: Is the WHERE clause optional in DELETE?
A: True

Q: DROP TABLE table_name;
A: How do you delete a table completely?

Q: All records in the table will be deleted
A: What happens if you omit WHERE in DELETE?